CREATE TABLE [dbo].[GiftAidClaimDetail]
(
[GiftAidClaimDetailKey] [uniqueidentifier] NOT NULL,
[GiftAidClaimHeaderKey] [uniqueidentifier] NOT NULL,
[ContactId] [int] NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_ContactId] DEFAULT ((0)),
[TransactionId] [int] NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_TransactionId] DEFAULT ((0)),
[TransactionPaidDate] [datetime] NULL,
[GiftAidDeclarationKey] [uniqueidentifier] NULL,
[TaxPayerTitle] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_TaxPayerTitle] DEFAULT (N''),
[TaxPayerFirstName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_TaxPayerFirstName] DEFAULT (N''),
[TaxPayerLastName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_TaxPayerLastName] DEFAULT (N''),
[DonationAmount] [money] NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_DonationAmount] DEFAULT ((0)),
[TaxReclaimAmount] AS (CONVERT([decimal](18,2),([DonationAmount]*[GiftAidTaxRate])/((100)-[GiftAidTaxRate]),(0))),
[GiftAidTaxRate] [money] NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_GiftAidTaxRate] DEFAULT ((0)),
[IsTaxReclaimAllocatedtoGeneralFund] [bit] NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_IsTaxReclaimAllocatedtoGeneralFund] DEFAULT ((0)),
[IsIncludedInClaim] [bit] NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_IsIncludedInClaim] DEFAULT ((0)),
[LabelName] AS (ltrim(rtrim((((isnull([TaxPayerTitle],'')+' ')+isnull([TaxPayerFirstName],N''))+N' ')+isnull([TaxPayerLastName],N'')))),
[HmrcReference] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GiftAidClaimDetail_HmrcReference] DEFAULT (N'')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GiftAidClaimDetail] ADD CONSTRAINT [PK_GiftAidClaimDetail] PRIMARY KEY CLUSTERED ([GiftAidClaimDetailKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GiftAidClaimDetail_GiftAidClaimHeaderKey] ON [dbo].[GiftAidClaimDetail] ([GiftAidClaimHeaderKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GiftAidClaimDetail] ADD CONSTRAINT [FK_GiftAidClaimDetail_GiftAidClaimHeader] FOREIGN KEY ([GiftAidClaimHeaderKey]) REFERENCES [dbo].[GiftAidClaimHeader] ([GiftAidClaimHeaderKey]) ON DELETE CASCADE
GO
GRANT REFERENCES ON  [dbo].[GiftAidClaimDetail] TO [IMIS]
GRANT SELECT ON  [dbo].[GiftAidClaimDetail] TO [IMIS]
GRANT INSERT ON  [dbo].[GiftAidClaimDetail] TO [IMIS]
GRANT DELETE ON  [dbo].[GiftAidClaimDetail] TO [IMIS]
GRANT UPDATE ON  [dbo].[GiftAidClaimDetail] TO [IMIS]
GO